SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001544s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 475044 LIMIT 1 [ RunTime:0.000372s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 475044 [ RunTime:0.001540s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (475825,527053,483698,752180,77203,20047,725901,351671,700935,251774,468816,270725,174137,108504,575901,68048,325087,1014681,140414,974923,252907,684746,690763,713783,164847,855746,132632,40772,139174,316747,113566,356160,989182,288232,124541,872180,608967,491276,46631,967913,478605,802747,365061,517145,600006,49117,1007119,920478,227798,46009,842041,144651,726045,955987,346057,343815,135049,261432,421001,1019442) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003039s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 475044 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000441s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 475044 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000616s ]