SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001096s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 409185 LIMIT 1 [ RunTime:0.000320s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 409185 [ RunTime:0.001733s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (980085,191560,50609,363454,39151,459445,771263,188672,821929,639552,205383,581947,108327,102917,635101,143884,291479,865950,54154,379819,495537,989807,469225,884892,132497,466450,537754,895135,51702,1016076,666736,359427,361140,898774,1008632,442239,687110,99908,484489,652321,958310,990018,636228,267602,276662,55248,247886,975535,388326,618759,584221,67242,553125,230920,754738,809072,663899,602201,520659,1028870) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000927s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 409185 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000340s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 409185 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000659s ]