SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001239s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 476412 LIMIT 1 [ RunTime:0.000399s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 476412 [ RunTime:0.001633s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (479629,38569,854896,500467,34694,692376,75684,118236,1021218,198992,593499,771172,830111,703023,14009,156930,778989,472492,112674,909399,334613,504537,1022713,57051,299802,152339,268995,637751,449571,252516,600555,391895,544490,494349,107284,877551,757646,830883,703249,664082,659480,1013641,364695,597348,977530,432529,787321,867003,182340,388882,896916,974384,207993,722156,379311,116753,939943,992733,843889,547183) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001237s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 476412 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000382s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 476412 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000402s ]