SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001118s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 574432 LIMIT 1 [ RunTime:0.000376s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 574432 [ RunTime:0.001726s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (762830,807929,728185,475667,721132,266844,214440,12751,493569,246004,1026290,166601,292677,753189,834026,200128,545111,862286,1014989,272768,197319,625068,302732,757371,1008406,220814,403113,73183,398365,656423,445665,901018,441773,1023758,462005,659327,188865,1026104,356534,10360,804207,369386,691838,911396,1006554,309616,1001342,334515,196312,199970,906940,613431,836951,439091,979639,813167,102057,188318,856820,311769) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001134s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 574432 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000342s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 574432 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000520s ]