SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001285s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 471281 LIMIT 1 [ RunTime:0.000390s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 471281 [ RunTime:0.001680s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (782538,304438,386107,586089,353311,1008636,589927,439400,571814,260441,1025704,443789,1010187,490086,241860,637179,218968,963216,1006403,889429,99073,418114,705596,782900,892926,524473,814100,557144,1017611,511949,172925,220229,418365,5576,911097,403693,500676,729368,32049,1005652,510096,915360,624099,92342,412192,544635,134509,848118,73321,332455,379500,154880,860709,715835,510430,938885,325265,1028880,804671,391052) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001254s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 471281 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000388s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 471281 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000540s ]