SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001143s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 315083 LIMIT 1 [ RunTime:0.000337s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 315083 [ RunTime:0.001825s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (52192,442879,395261,1045358,733264,642039,292272,837088,298009,295301,831354,601064,466046,420287,182500,390575,853661,387750,271505,788325,835215,711106,827973,405946,428730,162097,911308,135707,806284,349024,315326,566645,810091,686918,342159,336049,966516,653528,164016,907554,818499,530752,381788,115962,264742,969376,78718,420629,8214,983495,508857,1016497,399238,858860,524818,437409,135139,650687,617411,1006954) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001321s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 315083 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 315083 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000426s ]