SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001159s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 671029 LIMIT 1 [ RunTime:0.000335s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 671029 [ RunTime:0.002805s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (310121,1044883,577309,1028625,332665,214289,717706,880062,762391,651779,943860,877792,173221,707902,388411,881487,508394,736937,98870,272030,1024471,913903,535365,696019,77770,601364,378168,311242,1006335,247033,778033,233420,973619,204916,771272,898785,74592,393966,100486,343138,51044,167684,152330,883168,441318,582324,224426,811216,163076,287369,483305,169774,906792,830984,1023185,46372,53583,353769,580955,75535) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003131s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 671029 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000458s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 671029 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000682s ]