SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001205s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1040315 LIMIT 1 [ RunTime:0.000320s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1040315 [ RunTime:0.001625s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (466216,423099,1011104,214525,914951,217450,405708,1019420,405964,969716,950255,507947,705890,400419,587037,700647,710446,508166,512362,925261,412879,535422,832213,50468,768087,250857,954925,730038,217118,16701,968735,883047,629163,523771,950945,998881,526493,624248,321222,627956,256833,878027,70534,50779,889455,604788,721349,162868,480134,515160,86484,484586,871481,800783,319793,654246,287143,967928,596759,158201) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001031s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1040315 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000350s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1040315 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000552s ]