SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001620s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 506515 LIMIT 1 [ RunTime:0.002301s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 506515 [ RunTime:0.003015s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (210605,283050,300668,582895,466183,448669,90242,251130,792025,149551,515697,417821,278767,691938,695571,269016,359710,391346,400683,989095,573524,626937,300304,719191,955960,359358,673949,109622,281783,949269,925684,321083,793436,491951,326435,1032078,311018,830317,852500,3285,606742,266304,836480,3839,735560,698747,473697,152260,282691,422202,312873,444056,88147,152643,607814,188614,631224,111315,147752,539109) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001271s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 506515 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000378s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 506515 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000388s ]