SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001278s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 342923 LIMIT 1 [ RunTime:0.000314s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 342923 [ RunTime:0.006914s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (635052,529566,167308,813369,941679,633658,612980,111395,251291,152885,566325,894844,673073,939511,539767,843489,1024708,697204,771209,322987,892119,532470,315190,838603,1048129,109434,789464,334666,229308,619694,740005,44354,126879,404119,560695,437804,269700,739059,356747,887548,357503,905333,957184,578222,286367,767415,695916,802102,416702,658153,510710,945933,907344,298684,12423,871498,204019,493645,252700,635695) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001280s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 342923 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000430s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 342923 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000572s ]