SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001296s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 531828 LIMIT 1 [ RunTime:0.000382s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 531828 [ RunTime:0.001521s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (66716,148997,338766,404436,563739,899168,516685,26362,822155,643245,995324,386480,561205,125710,741344,42783,26888,777919,710365,175400,890843,665802,832093,749688,123675,402046,658175,954087,903373,732557,447347,138920,30940,371911,24962,755933,257385,496183,174623,406505,829197,302127,819771,366144,951903,456605,354130,689534,307498,430613,66224,385762,758401,519646,976801,471809,667876,784786,886380,441286) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001332s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 531828 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000354s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 531828 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000470s ]