SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001163s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1023433 LIMIT 1 [ RunTime:0.000337s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1023433 [ RunTime:0.003409s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (757750,488656,215557,104777,1012211,151568,679880,391061,906519,519894,371193,380060,58966,204122,580813,674334,260815,811428,95673,178930,503566,924840,194165,228366,874605,949735,893214,54513,56796,478927,740803,540478,224345,659323,268350,361489,14833,310854,247609,1022946,451074,655488,108614,46777,518921,383260,347551,315239,366665,653542,532710,840156,264940,769090,432819,459841,518590,231662,643474,67075) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.007173s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1023433 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001179s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1023433 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000631s ]