SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001410s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 605510 LIMIT 1 [ RunTime:0.003566s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 605510 [ RunTime:0.007168s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (177331,119124,495880,176708,502349,674990,571389,453340,1010847,662911,411045,715405,553132,106493,780821,643505,410525,732431,662829,776408,576038,640895,816352,67119,848974,98416,1023412,218724,1038491,767815,471869,191672,915919,83640,182059,430361,728138,556339,576152,267148,330377,970378,11287,235596,881017,57218,102784,130181,109825,690389,977242,967442,72312,47530,334271,496028,560514,1043215,160893,599153) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001327s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 605510 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000377s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 605510 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000540s ]