SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001277s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 473918 LIMIT 1 [ RunTime:0.000615s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 473918 [ RunTime:0.003569s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (67422,16322,752763,113434,1021777,956401,666439,989332,239441,837057,656084,610631,664943,301685,420423,350901,561360,977828,714549,684368,836895,264173,527166,464452,594373,33630,285266,1017824,375959,318874,901203,875663,794348,491369,167601,398161,1044213,573071,26145,1026101,79194,585054,751658,155653,845029,319671,812883,283255,793469,543533,405619,689485,959622,363160,826965,48806,305526,905026,984228,562954) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002482s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 473918 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000534s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 473918 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000613s ]