SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001083s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 415871 LIMIT 1 [ RunTime:0.000307s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 415871 [ RunTime:0.002729s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (402768,459354,289916,432968,219729,95605,894804,988494,946992,634698,752476,224102,749671,778527,1047901,760188,557762,913560,657824,948861,7337,107572,560395,853581,883006,61141,78009,780507,378564,316714,512371,511068,826892,833872,985149,984800,493429,577202,831559,969122,428558,474601,273444,999958,88145,137316,608445,817310,890401,57299,403099,988484,921226,307552,271742,56227,118026,399605,593452,511128) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001198s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 415871 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 415871 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000821s ]