SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001252s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 145607 LIMIT 1 [ RunTime:0.001098s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 145607 [ RunTime:0.007862s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1028776,10205,469228,313381,427858,633522,865381,555649,615667,845593,44617,447595,525335,121262,273928,416409,614145,655759,724425,307133,538597,235950,819725,221027,520817,270179,93356,81115,530092,83011,253080,451621,378047,827085,949013,976271,517771,7206,238399,250011,60661,834699,55140,112114,621162,485674,625337,55696,728689,1096,787555,344988,290466,796812,443044,664234,1006478,525723,241014,100010) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.044183s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 145607 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001633s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 145607 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001830s ]