SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001180s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 402439 LIMIT 1 [ RunTime:0.000364s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 402439 [ RunTime:0.002083s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (790505,95815,754894,453648,458370,930824,920078,453757,154725,1030538,530830,978945,305676,1012063,537193,627106,678047,815990,62057,821991,800348,536544,380953,753446,683779,167499,566592,755817,115650,1008977,972344,554511,620974,156218,206003,265311,975622,988754,330147,693046,748511,39333,434944,962903,14981,665566,351180,569101,606308,548680,918751,793241,271079,518657,930195,627529,354589,1031733,221560,992223) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001196s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 402439 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000592s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 402439 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000582s ]