SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001158s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 320 LIMIT 1 [ RunTime:0.000326s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 320 [ RunTime:0.001618s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (389913,1020294,669298,344220,148476,610998,233225,836415,1023015,23505,882278,812607,502268,748414,451079,85363,500184,108661,849657,688037,181356,798533,357297,896470,279491,984274,899730,606247,920771,361232,664151,688451,477758,210794,723786,793745,211735,131158,391432,808733,732535,51636,799192,855715,653568,457520,12874,799099,413764,999560,801365,850718,797172,436496,27089,832365,444815,442965,226102,261093) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001174s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 320 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001670s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 320 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000578s ]