SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003273s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 514620 LIMIT 1 [ RunTime:0.001451s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 514620 [ RunTime:0.005618s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (499172,966694,916078,27060,546414,1037081,279112,149167,210309,324386,707670,323870,547165,602697,60785,702001,370293,1014530,312626,319768,794290,654873,521256,675110,484340,225997,965685,324210,809547,62380,194879,807568,879212,683135,950094,623275,910834,261077,90509,137731,106462,365802,463451,124133,954299,734075,607708,36561,1013484,1009313,166339,547862,587159,442145,528275,879629,129331,337419,82840,576163) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003632s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 514620 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000907s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 514620 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000578s ]