SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001193s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 976013 LIMIT 1 [ RunTime:0.000307s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 976013 [ RunTime:0.002911s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (143266,668188,319946,251769,840863,599596,838152,553068,504399,746792,254825,613761,497483,634289,462649,439921,301403,579009,968493,634462,254966,106092,842749,523826,507423,1044571,270308,703775,81503,1040834,684541,33646,223429,760878,302561,511801,427736,778004,735836,428929,839359,956863,935190,434977,400075,1041642,357688,992408,394802,819094,160347,161682,328763,110919,753837,327717,699378,199015,394906,599549) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001423s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 976013 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001222s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 976013 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000508s ]