SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001250s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1018650 LIMIT 1 [ RunTime:0.000456s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1018650 [ RunTime:0.001830s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (778434,80666,428627,624115,374224,909545,210293,74832,305479,69261,678557,510840,986382,456215,505973,606295,866739,379592,990511,1020211,432025,947845,107835,267019,692349,779275,296166,411949,451926,101979,688970,685368,194751,322383,1016949,945630,114052,838573,924125,469193,229756,1558,581308,295652,933829,747799,81212,734401,555194,465942,800854,914795,141378,140335,212268,1008943,692215,390947,380291,29795) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000984s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1018650 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000350s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1018650 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000600s ]