SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001191s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 526993 LIMIT 1 [ RunTime:0.000321s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 526993 [ RunTime:0.001670s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (743343,913181,540183,772695,634073,337000,189423,2140,424254,146106,84693,378052,971557,484767,100209,98521,763893,955965,283916,414246,30794,523466,200232,965232,866512,836024,522200,279998,580305,615032,548990,536153,365879,446532,83100,652036,258468,56131,127533,785039,955952,594207,738337,433750,313781,915940,745485,287308,996896,1044741,375928,365382,872725,582055,148579,691532,905450,441141,399571,242485) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001089s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 526993 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000414s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 526993 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000528s ]