SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001207s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 542628 LIMIT 1 [ RunTime:0.000404s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 542628 [ RunTime:0.002345s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (391404,295103,545297,219796,629821,16499,933157,37859,934740,422802,632640,246952,654011,208984,266286,881002,448480,373298,839160,582286,1031,45300,1006192,218164,997139,900808,393479,908315,21508,597959,371767,1035559,312415,23342,831707,233197,772723,885574,736165,764668,779259,191658,809185,69906,110936,325806,934425,709724,704024,332826,280154,12141,682219,614630,439653,1045665,769522,647084,243081,984630) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001755s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 542628 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000418s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 542628 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001518s ]