SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001098s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 145203 LIMIT 1 [ RunTime:0.000307s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 145203 [ RunTime:0.001544s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (600505,357927,347877,823675,1019547,430515,573852,301567,126321,997452,577715,376632,926473,603731,236183,387706,307536,963445,813418,287083,510058,482053,902137,335459,231844,412123,394521,910613,902625,118202,252805,490042,518668,877013,122255,14134,528286,439239,599807,119602,990020,825803,189959,62638,1005529,916910,961879,781410,552155,268113,90697,659391,66738,201620,59032,36180,452022,101667,452561,417063) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001032s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 145203 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000340s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 145203 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000452s ]